Tabela LMedResourceOrgUnitJob

Definicja tabeli LMedResourceOrgUnitJob

Name

LMedResourceOrgUnitJob

Code

LMedResourceOrgUnitJob

Comment

PL: Przyporzadkowanie lekarza/urzadzenia do placówki
EN: Assignement medical resource to an organization unit


Lista kolumn tabeli LMedResourceOrgUnitJob

Name

Code

LPersonnelTypeID

LPersonnelTypeID

JobID

JobID

MedResourceID

MedResourceID

StartDT

StartDT

StopDT

StopDT

SequenceNo

SequenceNo


Kolumna LPersonnelTypeID tabeli LMedResourceOrgUnitJob

Definicja kolumny LPersonnelTypeID tabeli LMedResourceOrgUnitJob

Name

LPersonnelTypeID

Code

LPersonnelTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna JobID tabeli LMedResourceOrgUnitJob

Definicja kolumny JobID tabeli LMedResourceOrgUnitJob

Name

JobID

Code

JobID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MedResourceID tabeli LMedResourceOrgUnitJob

Definicja kolumny MedResourceID tabeli LMedResourceOrgUnitJob

Name

MedResourceID

Code

MedResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli LMedResourceOrgUnitJob

Definicja kolumny StartDT tabeli LMedResourceOrgUnitJob

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LMedResourceOrgUnitJob

Definicja kolumny StopDT tabeli LMedResourceOrgUnitJob

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna SequenceNo tabeli LMedResourceOrgUnitJob

Definicja kolumny SequenceNo tabeli LMedResourceOrgUnitJob

Name

SequenceNo

Code

SequenceNo

Data Type

NUMBER(10)

Mandatory

No

Comment

Sortowanie personelu na liscie grafiku dyzurów.


Lista kluczy tabeli LMedResourceOrgUnitJob

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LMedResourceOrgUnitJob

Definicja klucza Identifier_1 tabeli LMedResourceOrgUnitJob

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment